﻿CREATE PROCEDURE [dbo].[permissao_selectAll]
	@descricao nvarchar(30) = null
AS
	SET NOCOUNT ON
	SELECT TBPermissao.permissaoID,TBPermissao.descricao FROM TBPermissao 
	WHERE @descricao is null OR TBPermissao.descricao like '%' + @descricao + '%'
	ORDER BY TBPermissao.descricao